Created by A.J. Brown\ 27 Jan 2022\ Using Python 3.9.6\ Jupyter Lab 3.2.1\ Version 0.7
The following script is a tool to look at water quality data using the excel template that Emmanuel Deleon has developed for all water quality data. These graphs show data from ARDEC 2200 in 2019. Each script created would contain data from a new field. This script could be used by 1) the AWQP staff to look at preliminary data insights, and 2) stakeholders after QA/QC to allow them to look at publishable insights.
All samples are identified using abbreviations corresponding to locations as noted in the legend below:
| Sample ID Label | Location |
|---|---|
| A2 | ARDEC 2200 Field |
Use the below boxplot to graph various water analytes stratified by sample type (i.e., Inflow, Outflow, etc.). Analytes can be selected by using the dropdown menu on the top left of the graph. Hover over points with your mouse for additional information.
Use the below Scatter plot to graph various water analytes against each other to see potential relationships. Analytes can be selected by using the dropdown menus near top left of the graph. Hover over points with your mouse for additional information.
Use the below scatter matrix to look at potential relationships between numerical variables.
Points are stratified by sample type (i.e., Inflow, Outflow, etc.).
Hover over points with your mouse for additional information.
| Location | Date | Irr./Storm Event | Sample Type | Replication ID | Sample ID | Orthophosphate (mg/L) | NO3 (mg/L) | NH4 (mg/L) | TKN (mg/L) | Total Phosphorus (mg/L) | Selenium (mg/L) | E. coli. (Ct./100 mL) | Fecal Coliform (Ct./100 mL) | TSS (g/L) | Flow (GPM) | Notes | Year | hex | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | ARDEC 2200 | 6/23/2019 | S1 | OUTFLOW | 1 | A2-S1-OT | 0 | 5.0 | 0 | 3.40 | 0.480 | 0.0022 | 0.0 | 0.0 | 1.40 | NaN | NaN | 2019 | #1f77b4 |
| 1 | ARDEC 2200 | 6/23/2019 | S1 | OUTFLOW | 2 | A2-S1-OT-D | 0 | 4.9 | 0 | 2.60 | 0.460 | 0.0027 | 5000.0 | 5000.0 | 0.92 | NaN | NaN | 2019 | #1f77b4 |
| 2 | ARDEC 2200 | 7/5/2019 | S2 | OUTFLOW | 1 | A2-S2-OT-C1 | 0 | 2.8 | 0 | 40.00 | 1.500 | 0.0160 | 800.0 | 1000.0 | 15.82 | 2.212752e+04 | Part 1 | 2019 | #1f77b4 |
| 3 | ARDEC 2200 | 7/5/2019 | S2 | OUTFLOW | 2 | A2-S2-OT-C1-D | 0 | 2.8 | 0 | 28.00 | 2.800 | 0.0110 | 600.0 | 600.0 | 16.26 | 2.212752e+04 | Part 1 Dup | 2019 | #1f77b4 |
| 4 | ARDEC 2200 | 7/5/2019 | S2 | OUTFLOW | 1 | A2-S2-OT-C2 | 0 | 2.5 | 0 | 20.00 | 1.900 | 0.0120 | 400.0 | 400.0 | 9.11 | 1.907793e+04 | Part 2 | 2019 | #1f77b4 |
| 5 | ARDEC 2200 | 7/5/2019 | S2 | OUTFLOW | 2 | A2-S2-OT-C2-D | 0 | 2.5 | 0 | 21.00 | 2.200 | 0.0100 | 900.0 | 1000.0 | 8.94 | 1.907793e+04 | Part 2 Dup | 2019 | #1f77b4 |
| 6 | ARDEC 2200 | 7/5/2019 | S2 | OUTFLOW | 1 | A2-S2-OT-C3 | 0 | 2.2 | 0 | 18.00 | 2.100 | 0.0073 | 900.0 | 1400.0 | 6.00 | 9.303694e+03 | Part 3 | 2019 | #1f77b4 |
| 7 | ARDEC 2200 | 7/5/2019 | S2 | OUTFLOW | 2 | A2-S2-OT-C3-D | 0 | 2.2 | 0 | 18.00 | 1.300 | 0.0075 | 1200.0 | 1500.0 | 6.09 | 9.303694e+03 | Part 3 Dup | 2019 | #1f77b4 |
| 8 | ARDEC 2200 | 7/5/2019 | S2 | OUTFLOW | 1 | A2-S2-OT-C4 | 0 | 2.4 | 0 | 13.00 | 1.600 | 0.0077 | 1400.0 | 1500.0 | 5.22 | 1.207985e+04 | Part 4 | 2019 | #1f77b4 |
| 9 | ARDEC 2200 | 7/5/2019 | S2 | OUTFLOW | 2 | A2-S2-OT-C4-D | 0 | 2.3 | 0 | 10.00 | 1.200 | 0.0069 | 1400.0 | 1600.0 | 4.92 | 1.207985e+04 | Part 4 Dup | 2019 | #1f77b4 |
| 10 | ARDEC 2200 | 7/12/2019 | 1 | INFLOW | 1 | A2-01-IN | 0 | 10.0 | 0 | 4.20 | 0.440 | 0.0140 | 100.0 | 200.0 | 2.62 | NaN | Inflow- Grab | 2019 | #ff7f0e |
| 11 | ARDEC 2200 | 7/12/2019 | 1 | INFLOW | 2 | A2-01-IN-D | 0 | 10.0 | 0 | 4.80 | 0.048 | 0.0140 | NaN | NaN | 2.79 | NaN | Inflow- Grab - Dup | 2019 | #ff7f0e |
| 12 | ARDEC 2200 | 7/12/2019 | 1 | OUTFLOW | 1 | A2-01-OT | 0 | 9.9 | 0 | 1.20 | 0.460 | 0.0100 | 500.0 | 700.0 | 0.23 | 2.610865e+05 | NaN | 2019 | #1f77b4 |
| 13 | ARDEC 2200 | 7/12/2019 | 1 | OUTFLOW | 2 | A2-01-OT-D | 0 | 10.0 | 0 | 0.97 | 0.320 | 0.0120 | 200.0 | 200.0 | 0.19 | 2.610865e+05 | NaN | 2019 | #1f77b4 |
| 14 | ARDEC 2200 | 7/23/2019 | 2 | OUTFLOW | 1 | A2-O2-OT | 0 | 9.1 | 0 | 1.00 | 0.120 | 0.0098 | NaN | NaN | 0.12 | 1.889554e+05 | NaN | 2019 | #1f77b4 |
| 15 | ARDEC 2200 | 7/23/2019 | 2 | OUTFLOW | 2 | A2-02-OT-D | 0 | 9.1 | 0 | 1.30 | 0.130 | 0.0095 | NaN | NaN | 0.07 | 1.889554e+05 | NaN | 2019 | #1f77b4 |
| 16 | ARDEC 2200 | 8/3/2019 | 3 | OUTFLOW | 1 | A2-03-OT | 0 | 9.1 | 0 | 1.20 | 0.170 | 0.0092 | NaN | NaN | 0.10 | 5.394982e+04 | NaN | 2019 | #1f77b4 |
| 17 | ARDEC 2200 | 8/3/2019 | 3 | OUTFLOW | 2 | A2-03-OT-D | 0 | 9.1 | 0 | 1.50 | 0.170 | 0.0100 | NaN | NaN | 0.12 | 5.394982e+04 | NaN | 2019 | #1f77b4 |
| 18 | ARDEC 2200 | 8/3/2019 | 3 | GATED PIPE | 1 | A2-03-WL | 0 | 9.3 | 0 | 0.00 | 0.000 | 0.0093 | NaN | NaN | 0.02 | NaN | NaN | 2019 | #2ca02c |
| 19 | ARDEC 2200 | 8/3/2019 | 3 | INFLOW | 1 | A2-03-IN | 0 | 9.2 | 0 | 3.00 | 0.200 | 0.0110 | NaN | NaN | 1.02 | NaN | NaN | 2019 | #ff7f0e |
| 20 | ARDEC 2200 | 8/3/2019 | 3 | INFLOW | 2 | A2-03-IN-D | 0 | 9.2 | 0 | 3.00 | 0.210 | 0.0110 | NaN | NaN | 1.05 | NaN | NaN | 2019 | #ff7f0e |
| 21 | ARDEC 2200 | 8/6/2019 | 4 | OUTFLOW | 1 | A2-04-OT | 0 | 8.1 | 0 | 0.00 | 0.160 | 0.0100 | 800.0 | 900.0 | 0.14 | 1.429689e+06 | NaN | 2019 | #1f77b4 |
| 22 | ARDEC 2200 | 8/6/2019 | 4 | OUTFLOW | 2 | A2-04-OT-D | 0 | 8.1 | 0 | 0.00 | 0.150 | 0.0096 | 790.0 | 950.0 | 0.14 | 1.429689e+06 | NaN | 2019 | #1f77b4 |
| 23 | ARDEC 2200 | 8/6/2019 | 4 | INFLOW | 1 | A2-04-IN | 0 | 8.3 | 0 | 2.70 | 0.240 | 0.0099 | 150.0 | 150.0 | 1.08 | NaN | NaN | 2019 | #ff7f0e |
| 24 | ARDEC 2200 | 8/6/2019 | 4 | INFLOW | 2 | A2-04-IN-D | 0 | 8.2 | 0 | 3.10 | 0.420 | 0.0100 | 180.0 | 180.0 | 2.14 | NaN | NaN | 2019 | #ff7f0e |
| 25 | ARDEC 2200 | 8/18/2019 | 5 | OUTFLOW | 1 | A2-05-OT | 0 | NaN | 0 | 1.40 | 0.240 | NaN | NaN | NaN | 0.13 | 3.518484e+05 | NaN | 2019 | #1f77b4 |
| 26 | ARDEC 2200 | 8/18/2019 | 5 | OUTFLOW | 2 | A2-05-OT-D | 0 | NaN | 0 | 1.60 | 0.340 | NaN | NaN | NaN | 0.16 | 3.518484e+05 | NaN | 2019 | #1f77b4 |
| 27 | ARDEC 2200 | 8/22/2019 | 6 | OUTFLOW | 1 | A2-06-OT | 0 | 7.7 | 0 | 0.00 | 0.100 | 0.0099 | NaN | NaN | 0.12 | 9.881645e+05 | NaN | 2019 | #1f77b4 |
| 28 | ARDEC 2200 | 8/22/2019 | 6 | OUTFLOW | 2 | A2-06-OT-D | 0 | 7.7 | 0 | 0.00 | 0.190 | 0.0097 | NaN | NaN | 0.12 | 9.881645e+05 | NaN | 2019 | #1f77b4 |
| 29 | ARDEC 2200 | 8/22/2019 | 6 | GATED PIPE | 1 | A2-06-WL | 0 | 7.7 | 0 | 0.00 | 0.000 | 0.0100 | NaN | NaN | 0.04 | NaN | NaN | 2019 | #2ca02c |
| 30 | ARDEC 2200 | 8/22/2019 | 6 | INFLOW | 1 | A2-06-IN | 0 | 7.7 | 0 | 2.40 | 0.170 | 0.0100 | NaN | NaN | 0.76 | NaN | NaN | 2019 | #ff7f0e |
| 31 | ARDEC 2200 | 8/22/2019 | 6 | INFLOW | 2 | A2-06-IN-D | 0 | 7.7 | 0 | 2.50 | 0.250 | 0.0098 | NaN | NaN | 0.71 | NaN | NaN | 2019 | #ff7f0e |